
-- Ref: http://blog.sqlauthority.com/2007/03/15/sql-server-dbcc-reseed-table-identity-value-reset-table-identity/

DBCC CHECKIDENT (yourtable, reseed, 34);

USE SGLDBMP01;
GO

DBCC CHECKIDENT (StatusCode, RESEED, 0);

/* OP:
Checking identity information: current identity value '6'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

*/